Map Debug Tools
##
## === DIAGNOSTIC: Building Details All Students Data ===
## Number of rows: 105
## Column names: Building IRN, Building Name, District_IRN, District Name, County, Region, Student Group, Enrollment, Enrollment Percent, Attendance Rate, Mobility Rate, Chronic Absenteeism Rate
## Sample Building IRNs: 000224, 000489, 000575, 000729, 000736
## === After renaming columns ===
## # A tibble: 3 × 6
## SchoolIRN SchoolName Enrollment_Percent Attendance_Rate Mobility_Rate
## <chr> <chr> <chr> <chr> <chr>
## 1 000224 Adlai Stevenson Sc… 100.0 87.6 20.0
## 2 000489 Almira 100.0 86.1 8.5
## 3 000575 Northwest School o… 100.0 84.2 27.5
## # ℹ 1 more variable: Chronic_Absenteeism_Rate <chr>
##
## === After numeric conversion ===
## # A tibble: 3 × 6
## SchoolIRN SchoolName Enrollment_Percent Attendance_Rate Mobility_Rate
## <chr> <chr> <dbl> <dbl> <dbl>
## 1 000224 Adlai Stevenson Sc… 1 0.876 0.2
## 2 000489 Almira 1 0.861 0.085
## 3 000575 Northwest School o… 1 0.842 0.275
## # ℹ 1 more variable: Chronic_Absenteeism_Rate <dbl>
## Using geocoded school data
##
## === DIAGNOSTIC: Cleveland Schools Data (before merge) ===
## Number of rows: 105
## Column names: SchoolIRN ..., SchoolName ..., DistrictIRN ..., DistrictName ..., Latitude ..., Longitude ..., SyntheticCoords ..., geo_lat ..., geo_lng ..., geo_address ..., Address ...
## Sample SchoolIRNs: 000224, 000489, 000575, 000729, 000736
##
## === DIAGNOSTIC: SchoolIRN Comparison ===
## First 5 SchoolIRNs in Cleveland Schools Data: 000224, 000489, 000575, 000729, 000736
## First 5 SchoolIRNs in Building Details Data: 000224, 000489, 000575, 000729, 000736
## Number of matching SchoolIRNs: 105 out of 105 schools
##
## === DIAGNOSTIC: Cleveland Schools Data (after merge) ===
## Number of rows: 105
## Sample of joined data:
## # A tibble: 3 × 6
## SchoolName SchoolIRN Enrollment_Percent Attendance_Rate Mobility_Rate
## <chr> <chr> <dbl> <dbl> <dbl>
## 1 Adlai Stevenson Sc… 000224 1 0.876 0.2
## 2 Almira 000489 1 0.861 0.085
## 3 Northwest School o… 000575 1 0.842 0.275
## # ℹ 1 more variable: Chronic_Absenteeism_Rate <dbl>
##
## Cleveland Buildings 22-23: 973 rows
## Cleveland Buildings 23-24: 936 rows
## Cleveland Buildings 23-24 (All Students): 105 rows
## Cleveland Student Opportunity 22-23: 1090 rows
## Cleveland Student Opportunity 23-24: 1050 rows
## Cleveland Schools Data: 105 rows
## Schools with values for Attendance Rate: 105
## Schools with values for Chronic Absenteeism Rate: 105
## Schools with values for Mobility Rate: 105
## Schools with values for Enrollment Percent: 105
## [1] "Schools data summary:"
## [1] "Number of schools: 105"
## [1] "School columns: SchoolIRN, SchoolName, DistrictIRN, DistrictName, Latitude, Longitude, SyntheticCoords, geo_lat, geo_lng, geo_address"
## [1] "Sample coordinates: -81.5509837, -81.7518031, -81.7671731 41.4548682, 41.4616156, 41.482455"
## Map dimensions: x
The map below allows you to select different performance indicators to visualize across schools in Cleveland. Each indicator is color-coded to show variation in performance, with HOLC redlining districts displayed as background polygons.
Select Performance Indicator:
## [1] "Available columns in cleveland_schools_data:"
## [1] "SchoolIRN" "SchoolName"
## [3] "DistrictIRN" "DistrictName"
## [5] "Latitude" "Longitude"
## [7] "SyntheticCoords" "geo_lat"
## [9] "geo_lng" "geo_address"
## [11] "Address" "Enrollment_Percent"
## [13] "Attendance_Rate" "Mobility_Rate"
## [15] "Chronic_Absenteeism_Rate"
Schools are displayed on top of the historical redlining districts from the 1930s HOLC. The system automatically handles “NC” (not counted) values by treating them as missing data. Use the dropdown above the map to switch between indicators - the school dots will change colors accordingly, and a dynamic legend shows the color scale for each indicator.
The maps below visualize data from the Building Student Opportunity Report for Cleveland schools. Each indicator shows opportunities and resources available to students, with HOLC redlining districts displayed as background polygons.
Select Student Opportunity Indicator:
## Loaded Student Opportunity data for 105 schools
## Available indicators:
## - All-Day Kindergarten Enrollment : 105 schools with data
## - Physical Education/Wellness Course Enrollment : 105 schools with data
## - World Language Course Enrollment : 105 schools with data
## - Career Technical Education Enrollment (Grades 7-12) : 105 schools with data
## - Cocurricular Activities Participation : 105 schools with data
## - Advanced Courses Participation (AP, IB, Honors, CCP) : 105 schools with data
## - Gifted Services : 105 schools with data
## - Enrichment/Support Programs Outside School Day : 105 schools with data
## - School Breakfast Program Participation : 105 schools with data
## - Students Transported by School Bus : 105 schools with data
## - Portable Technology Devices Ratio : 105 schools with data